Query: |
SELECT jp.`id`,`FirmsName`,`FirmsAddress`,`EmailAddress`,`Website`,`LogoPath`,`City`,`Country`,`RecruiterId`,`JobTitle`,`Category`,`Description`,`Country`,`Location`,`Status`,`Salary`,`tbd`
FROM `jobposts` jp
INNER JOIN `jobscountries` cn ON cn.id=jp.`CountryId`
INNER JOIN `category` ca ON ca.id=jp.`CategoryId`
INNER JOIN `recruiter` ON `recruiter`.`id`=jp.`RecruiterId`
WHERE jp.`id`=4Dڝ
ORDER BY jp.`PostedDate` DESC, jp.`id` DESC LIMIT 0,35
|